﻿using System;

namespace Wheeler.Domain
{
    public static class DbObject
    {
        /// <summary>
        /// Contains the Names of the Stored Procedures
        /// Stored Procedure's names should not be prefixed with dob. as SQL Server.
        /// It is interpreted as DatabaseName.Procedure name and hence produces 
        /// Procedure not found exception in MySQL
        /// </summary>
        public static class SP
        {
            public const String GET_VEHICLE_LIST = "GetPagedVehicleList"; //Not added
            public const String GET_TESTRESULT_LIST = "GetPagedTestResultList"; //Not Added
            public const String GET_LOOKUP_DATA = "GetLookupData";
            public const String GET_PAGED_TEST_RESULT = "GetPagedTestResult";
            public const String GET_USER_LIST = "GetUserList";
        }

        /// <summary>
        /// Contains the Names of the Database Functions
        /// </summary>
        public static class Function
        {
            
        }
        
        /// <summary>
        /// Conntains the Names of the Database Views
        /// </summary>
        public static class View
        {

        }

        public enum TestStatus : int
        {
            PASSED = 1,
            FAILED = 2,
            NOT_TESTED = 3,
            NONE = 4
        }
    }
}
